UCF STIG Viewer Logo
Changes are coming to https://stigviewer.com. Take our survey to help us understand your usage and how we can better serve you in the future.
Take Survey

The Oracle RESOURCE_LIMIT parameter should be set to TRUE.


Overview

Finding ID Version Rule ID IA Controls Severity
V-2593 DO3696-ORACLE11 SV-24942r1_rule ECLO-1 Medium
Description
The Oracle RESOURCE_LIMIT parameter determines whether resource limits are enforced in database profiles. If Oracle resource limits are disabled, any defined profile limits will be ignored. NOTE: This does not apply to password resources.
STIG Date
Oracle 11 Database Instance STIG 2014-01-14

Details

Check Text ( None )
None
Fix Text (F-26553r1_fix)
Enable resource limit checking on the database.

From SQL*Plus:

alter system set resource_limit = TRUE scope = both;

The above SQL*Plus command will set the parameter to take effect immediately and permanently at next system startup.